... <看更多>

You can generate statement like this: DROP TABLE t1, t2, t3, ... and then use prepared statements to execute it: SET FOREIGN_KEY_CHECKS = 0; SET @tables ... ... <看更多>

First do a. SELECT CONCAT('DROP TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ';') FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '\_elgg%' AND TABLE_SCHEMA ... ... <看更多>